require "mysql"

my = Mysql::new("localhost", "root", "password", "myphone")
my.query("create table kanchilug (sno integer(5) not null auto_increment primary key,name varchar(25),phone varchar(15))")
my.query("insert into kanchilug values(1,'Arulalan','9994332225')")
file=File.open("Kanchi_Lug_Contacts","r")
file.each do |name_and_no|
name_and_no.chomp!
contact=name_and_no.split(/,/)
my.query("insert into kanchilug values('','#{contact[0]}','#{contact[1]}')")
end
my.close
print " Kanchi Lug Members Contact Saved "

